package com.sitaoke.stocks.dao;
import java.util.List;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.sitaoke.stocks.pojo.Stock;

public interface StockRespository extends CrudRepository<Stock, String>{

	@Query(value = "SELECT * FROM T_STOCK T ORDER BY T.DISPLAY_ORDER ASC", nativeQuery = true)
	List<Stock> findAllByDisplayOrder();

}
